|
Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server. This allows to continue using Microsoft Access as a database front-end whereas the actual back-end is served by a separate local or remote SQL Server allowing much higher productivity and data volumes. Microsoft Access from the version 2000 on has a special ''Upsizing Wizard'' which facilitates the data migration to the proprietary Microsoft SQL Server. No other RDBMS are currently supported for upsizing. ==Upsizing strategies== There are two strategies how database can be migrated from Access to a SQL Server. #Using ODBC from Microsoft to get access to a remote database via ADO. #Using Access Projects (available in Microsoft Access 2000 and higher) which allow more "native" integration with Microsoft SQL Server. The first strategy is often seen as the first step towards complete migration on a SQL server on the stage 2,〔Thomas Groß,Claudia Clemens "Upsizing von Access zu SQL Server", dotnetpro 6/2004〕 and can be seen as a part of the strategy 2. For peculiarities of every strategy see the table. 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「Upsizing (database)」の詳細全文を読む スポンサード リンク
|